<!DOCTYPE html>
<html lang="en">
    <head>
		<meta charset="utf-8">
		<title>AP Forest Department R &amp; D Circle</title>
		<meta name="viewport" content="width=device-width, initial-scale=1.0">
		<meta name="description" content="">
		<meta name="author" content="">
		<link rel="shortcut icon" type="image/x-icon" href="images/favicon.png" /> 
		<!-- Le styles -->
		<link href='http://fonts.googleapis.com/css?family=Monda' rel='stylesheet' type='text/css'>
		<link href="css/style.css" rel="stylesheet">
		<link rel="stylesheet" href="css/jquery.bxslider.css">
		<link href="css/aptable-responsive.css" rel="stylesheet">
		<script src="js/jquery.min.js"></script>
		<script src="js/jquery.bxslider.js"></script>
		
	</head>
	<body>
		<div class="container">
			<div class="well">
				<div class="logo view_mar_top" style="float:left; ">
				   <img src="images/apfd-Logo.png"/>
				</div>
				<div style="style= float:right;margin-top:50px;">
					<div class="apdiv">
						<h1>ANDHRA PRADESH FOREST DEPARTMENT</h1>
					</div>
					<div class="apdiv">
						<h2>RESEARCH AND DEVELOPMENT CIRCLE</h2>
					</div>
					<div class="apdiv">
						<h3>SEED AVAILABILITY INFORMATION</h3>
					</div>
				</div>
				<div class="clear"></div>
				<div style=" margin-top:20px; margin-bottem:20px;">
					<div class="slider1">
						<div class="slide">
						<img src="images/Pterocarpus-marsupium.jpg" alt="Pterocarpus marsupium"></a>
						<h4>Pterocarpus marsupium</h4>
						</div>
						
						<div class="slide">
						<img src="images/Seeds-of-Peltophorum-pterocarpum.jpg" alt="Peltophorum pterocarpum"></a>
						<h4>Peltophorum pterocarpum</h4>
						</div>
						
						<div class="slide">
						<img src="images/Acacia-sandra.jpg" alt="Acacia sandra"></a>
						<h4>Acacia sandra</h4>
						</div>
						
						<div class="slide">
						<img src="images/Seeds-of-Cochlospermum-religiosum-3.jpg" alt="Cochlospermum-religiosum"></a>
						<h4>Cochlospermum religiosum</h4>
						</div>
						
						<div class="slide">
						<img src="images/Seeds-of-Hardwickia-binata.jpg" alt="Hardwickia binata"></a>
						<h4>Hardwickia binata</h4>
						</div>
						
						<div class="slide">
						<img src="images/Tectona-grandis.jpg" alt="Tectona grandis"></a>
						<h4>Tectona grandis</h4>
						</div>
		  
					</div>
				</div>
				<div class="apdiv">
					<div class="span10">
						<p>This information reflects the quantities of seed of various species available with the two Research Divisions of Andhra Pradesh Forest Department and is updated continuously. Required quantities may be indented from the Reseach Divisions with whom the seeds are available. While indenting with the Research Division, please mark a copy of the indent to the APCCF(R&D) for information.</p>
						<p>If you need the seed of any of the species other than those listed below, please place an indent well in time along with the information such as the nursery season for which the seeds are required.</p>
					</div>
				</div>
				<div class=" span10 ap_item_per_kg">
					<p><li>( Quantities are in KGs )</li><span>Enter Keyword Search:&nbsp;<input type="text" id="search"/> </span></p>
				</div>
				<div class="clear"></div>
				<div class="table_bg">
					<div class="span10">
						<div class="aptable">
						<table class="ap_table" id="tblData">
                       <thead>
                            <tr>
                                <th>Botanical name</th>
                                <th>Common Name</th>
                                <th>SS, Rajahmundry</th>
								<th>SS, Tirupathi</th>
								<th>TOTAL</th>
								<th>Remarks</th>
                            </tr>
                        </thead>
                        <tbody>
                        <?php
						ini_set('display_errors', '0');
						include("connect.php");
						$query = mysql_query("SELECT * FROM information ORDER BY bname ASC");
						$i=0;
						while($fetch = mysql_fetch_array($query))
						{
							if($fetch['remarks']=='')
							{
								$fetch['remarks']="&nbsp;";
							}
							if($fetch['cname']=='')
							{
								$fetch['cname']="&nbsp;";
							}
							if($i%2==0) $class = 'even'; else $class = 'odd';
							echo'<tr class="'.$class.'" id="tr_'.$fetch['id'].'">
                                <td><span class= "xedit" id="'.$fetch['id'].'" name="bname">'.$fetch['bname'].'</span></td>
                                <td><span class= "xedit" id="'.$fetch['id'].'"  name="cname">'.$fetch['cname'].'</span></td>
                                <td><span class= "xedit" id="'.$fetch['id'].'"  name="ssr">'.$fetch['ssr'].'</span></td>
								<td><span class= "xedit" id="'.$fetch['id'].'"  name="sst">'.$fetch['sst'].'</span></td>
								  <td><span id="'.$fetch['id'].'"  name="total">'.($fetch['ssr']+$fetch['sst']).'</span></td>
								   <td><span class= "xedit" id="'.$fetch['id'].'"  name="remarks">'.$fetch['remarks'].'</span></td>
                            </tr>';	
						}
						?>
                        </tbody>
						<?php 
							$add=mysql_query('SELECT SUM(ssr),SUM(sst) from information');
							while($row1=mysql_fetch_array($add))
							{
							$rajahmundry=$row1['SUM(ssr)'];
							$tirupathi=$row1['SUM(sst)'];
							$total=$rajahmundry+$tirupathi;
						?>
						
					  
						<tr>
                                <th>&nbsp;</th>
                                <th>&nbsp;</th>
                                <th><?php echo $rajahmundry;?></th>
								<th><?php echo $tirupathi;?></th>
								<th><?php echo $total;?></th>
								<th>&nbsp;</th>
                        </tr>
						<?php } ?>
						</table>
						</div>
					</div>
				</div>
				<div class="clear"></div>
				<div class="apdiv_bottom">
					<h3>CELL NUMBERS OF RESEARCH OFFICERS </h3>
				</div>
				<div class="apdiv_bottom_p">
				<p class="ap_info_active">These numbers are for enquiries only. Indents need to be placed in writing. Kindly follow up all oral indents with written indents.</p>
				<div class="contact_info">
					<table class="ap_contact_info">
						   <thead>
								<tr>
									<th>State Silviculturist, TIRUPATHI</th>
									<th>State Silviculturist, RAJAHMUNDRY</th>
								</tr>
							</thead>
							<tr>
								<td>94408 10150</td>
								<td>94408 10153</td>
							</tr>
					</table>
				</div>
					<p>Developed and maintained by the Research & Development Circle, Andhra Padesh Forest Department.</p>
					<p>Please send suggestions on further improvement of this webpage to <a href="mailto:bvpreddy@gmail.com">bvpreddy@gmail.com</a></p>
				</div>
			</div>
		</div>
	</body>
</html>
<script>
	$(document).ready(function()
{
	$('#search').keyup(function()
	{
		searchTable($(this).val());
	});
});

$(document).ready(function(){
    $('.slider1').bxSlider({
		slideWidth: 282,
		minSlides: 2,
		maxSlides:4,
		auto: true,
		slideMargin:10  
	});
 });
 
function searchTable(inputVal)
{
	var table = $('#tblData');
	table.find('tr').each(function(index, row)
	{
		var allCells = $(row).find('td');
		if(allCells.length > 0)
		{
			var found = false;
			allCells.each(function(index, td)
			{
				var regExp = new RegExp(inputVal, 'i');
				if(regExp.test($(td).text()))
				{
					found = true;
					return false;
				}
			});
			if(found == true)$(row).show();else $(row).hide();
		}
	});
}
</script>